Model Table WORK ORDER

This model dimension represents work order information and is based on the IFS Cloud dimension DIM_WORK_ORDER.

Attributes

Attribute	Description (where applicable)
Work Leader Sign	Work leader signature (WORK_LEADER_SIGN)
Work Master Sign	Work master signature (WORK_MASTER_SIGN)
Work Order	Key. Defined as WO_NO (work order number)
Work Order Call Code	Maintenence event identity (CALL_CODE)
Work Order Discovery	Defined as the description of the work order discover code (DISCOVER_DESCRIPTION)
Work Order Error Cause	Defined as the description of the maintenance error cause (ERR_CAUSE_DESCRIPTION)
Work Order Error Class	Defined as the description of the work order error class identity (ERR_CLASS_DESCRIPTION)
Work Order Error Symptom	Defined as the description of the work order error symptom code (SYMPTOM_DESCRIPTION)
Work Order Error Type	Defined as the description of the work order error type code (ERR_TYPE_DESCRIPTION)
Work Order Operational Status	Defined as the operational status of the work order.
Work Order Performed Action	Defined as the description of the performed action (PERFORMED_ACTION_DESCRIPTION)
Work Order Priority	Defined as the description of the work order priority (PRIORITY_DESCRIPTION)
Work Order Reported By	The identity of reporting user (REPORTED_BY)
Work Order Site Code	Defined as the work order site
Work Order Status	The status of the work order (STATUS)
Work Order Work Type	Defined as the work order type description (WORK_TYPE_DESC)

USED BY MODEL(S)

Model Name

Maintenance

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
WORK ORDER	DIM_WORK_ORDER_TM	DIM_WORK_ORDER_BI	DIM_WORK_ORDER	On Line